package com.kuang.dao.provider;

import com.kuang.pojo.Provider;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface ProviderDao {


    //增加供应商
    public int add(Connection connection,Provider provider) throws Exception;

    //查询供应商列表
    public List<Provider> getProviderList(Connection connection) throws Exception;

    //通过供应商名称或编码获取 供应商列表 -- 模糊查询
    public List<Provider> getProviderLists(Connection connection,String providerName,String providerCode) throws Exception;

    //通过proId删除provider
    public int deleteProviderById(Connection connection,String delId)throws Exception;

}
